Queries[edit]

Colocation[edit]

SELECT count(colocated)
FROM "volumes"
where colocated is not null

1326

Top Submitters[edit]

sqlquery -en ceurws -qp ceurws.yaml -qn SubmittedByGt6 -f mediawiki

SubmittedByGt6ForWiki[edit]

Colocation[edit]

SELECT count(colocated)
FROM "volumes"
where colocated is not null

1326

Top Submitters[edit]

sqlquery -en ceurws -qp ceurws.yaml -qn SubmittedByGt6 -f mediawiki

SubmittedByGt6ForWiki[edit]

query[edit]

SELECT count(*) as count,"{{Link|target="||submittedBy||"}}"
FROM "volumes"
GROUP BY submittedBY
HAVING COUNT(*) > 6
ORDER BY 1 DESC

result[edit]